SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROC [dbo].[usp_Booking]
	@SO_BOOKING		CHAR(15),
	@HO_TEN_BOOKING	NVARCHAR(50),
	@TEN_CTY		NVARCHAR(50),
	@DIA_CHI_BOOKING	NVARCHAR(100),
	@EMAIL			VARCHAR(50),
	@MS_THUE		CHAR(10),
	@GIA			INT,
	@MA_TOUR		CHAR(20),
	@DIEN_THOAI1 	VARCHAR(12),
	@DIEN_THOAI2 	VARCHAR(12)
AS
BEGIN
		DECLARE @TG_DAT DATETIME
		SET @TG_DAT = GETDATE()

		INSERT INTO KHACH_HANG_BOOKING VALUES
		(@SO_BOOKING, @HO_TEN_BOOKING, @TEN_CTY, @DIA_CHI_BOOKING, @EMAIL, @MS_THUE, @GIA, @TG_DAT, NULL, @MA_TOUR, 'CHUA',@DIEN_THOAI1,@DIEN_THOAI2)      
END 

GO
